﻿<%@ Control Language="C#" AutoEventWireup="true" CodeFile="Statistics.ascx.cs" Inherits="webUserControl_Statistics" %>
<div class="code">

    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:LinFen %>" 
        SelectCommand="SELECT [ID], [CityName] FROM [sysCityName]">
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
        ConnectionString="<%$ ConnectionStrings:LinFen %>" 
        SelectCommand="SELECT [ID], [DistrictName] FROM [sysDistrictName] WHERE ([CityID] = @CityID)">
        <SelectParameters>
            <asp:ControlParameter ControlID="ddlCityID" Name="CityID" 
                PropertyName="SelectedValue" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
        ConnectionString="<%$ ConnectionStrings:LinFen %>" 
        SelectCommand="SELECT [ID], [DangCiName] FROM [sysDangCi]">
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource4" runat="server" 
        ConnectionString="<%$ ConnectionStrings:LinFen %>" 
        SelectCommand="SELECT [ID], [ClassName] FROM [sysCatalog]">
    </asp:SqlDataSource>
    地市：<asp:DropDownList ID="ddlCityID" runat="server" AutoPostBack="True" 
        DataSourceID="SqlDataSource1" DataTextField="CityName" DataValueField="ID" 
        onselectedindexchanged="ddlCityID_SelectedIndexChanged">
    </asp:DropDownList>
    <asp:DropDownList ID="ddlDistrictID" runat="server" 
        DataSourceID="SqlDataSource2" DataTextField="DistrictName" DataValueField="ID">
    </asp:DropDownList>
&nbsp;档次：<asp:DropDownList ID="ddlDangCiID" runat="server" 
        DataSourceID="SqlDataSource3" DataTextField="DangCiName" DataValueField="ID">
    </asp:DropDownList>
&nbsp;分类：<asp:DropDownList ID="ddlCatalogID" runat="server" 
        DataSourceID="SqlDataSource4" DataTextField="ClassName" DataValueField="ID">
    </asp:DropDownList>
    <asp:Button ID="btnSub" runat="server" onclick="btnSub_Click" Text="查询" />

</div>
<style type="text/css">
    td
    {
        background-color:White;
    }
</style>
<table style="width:100%; line-height:25px; text-align:center; background-color:blue; font-size:12px; color:Black;" cellspacing=1>
<tr>
    <td></td>
    <td>男</td>
    <td>女</td>
    <td>烘干器</td>
    <td>包间</td>
    <td>其他</td>
    <td>总计</td>
</tr>
<tr>
    <td>已发布</td>
    <td>
        <asp:Label ID="lblMale1" runat="server" Text=""></asp:Label>
            </td>
    <td>
        <asp:Label ID="lblFemale1" runat="server"></asp:Label>
            </td>
    <td>
        <asp:Label ID="lblHongGan1" runat="server"></asp:Label>
            </td>
    <td>
        <asp:Label ID="lblBaoJian1" runat="server"></asp:Label>
            </td>
    <td>
        <asp:Label ID="lblQiTa1" runat="server"></asp:Label>
            </td>
    <td>
        <asp:Label ID="lblTotal1" runat="server"></asp:Label>
            </td>
</tr>
<tr>
    <td>招商空</td>
    <td>
        <asp:Label ID="lblMale2" runat="server" Text=""></asp:Label>
            </td>
    <td>
        <asp:Label ID="lblFemale2" runat="server"></asp:Label>
            </td>
    <td>
        <asp:Label ID="lblHongGan2" runat="server"></asp:Label>
            </td>
    <td>
        <asp:Label ID="lblBaoJian2" runat="server"></asp:Label>
            </td>
    <td>
        <asp:Label ID="lblQiTa2" runat="server"></asp:Label>
            </td>
    <td>
        <asp:Label ID="lblTotal2" runat="server"></asp:Label>
            </td>
</tr>
<tr>
    <td>合计</td>
    <td>
        <asp:Label ID="lblMale3" runat="server" Text=""></asp:Label>
            </td>
    <td>
        <asp:Label ID="lblFemale3" runat="server"></asp:Label>
            </td>
    <td>
        <asp:Label ID="lblHongGan3" runat="server"></asp:Label>
            </td>
    <td>
        <asp:Label ID="lblBaoJian3" runat="server"></asp:Label>
            </td>
    <td>
        <asp:Label ID="lblQiTa3" runat="server"></asp:Label>
            </td>
    <td>
        <asp:Label ID="lblTotal3" runat="server"></asp:Label>
            </td>
</tr>
<tr>
    <td >空租率%</td>
    <td >
        <asp:Label ID="lblMale4" runat="server" Text=""></asp:Label>
            </td>
    <td>
        <asp:Label ID="lblFemale4" runat="server"></asp:Label>
            </td>
    <td>
        <asp:Label ID="lblHongGan4" runat="server"></asp:Label>
            </td>
    <td >
        <asp:Label ID="lblBaoJian4" runat="server"></asp:Label>
            </td>
    <td>
        <asp:Label ID="lblQiTa4" runat="server"></asp:Label>
            </td>
    <td>
        <asp:Label ID="lblTotal4" runat="server"></asp:Label>
            </td>
</tr>
</table>